package com.hebeu.device.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class DServiceDeviceExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public DServiceDeviceExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andDevIdIsNull() {
            addCriterion("dev_id is null");
            return (Criteria) this;
        }

        public Criteria andDevIdIsNotNull() {
            addCriterion("dev_id is not null");
            return (Criteria) this;
        }

        public Criteria andDevIdEqualTo(Integer value) {
            addCriterion("dev_id =", value, "devId");
            return (Criteria) this;
        }

        public Criteria andDevIdNotEqualTo(Integer value) {
            addCriterion("dev_id <>", value, "devId");
            return (Criteria) this;
        }

        public Criteria andDevIdGreaterThan(Integer value) {
            addCriterion("dev_id >", value, "devId");
            return (Criteria) this;
        }

        public Criteria andDevIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("dev_id >=", value, "devId");
            return (Criteria) this;
        }

        public Criteria andDevIdLessThan(Integer value) {
            addCriterion("dev_id <", value, "devId");
            return (Criteria) this;
        }

        public Criteria andDevIdLessThanOrEqualTo(Integer value) {
            addCriterion("dev_id <=", value, "devId");
            return (Criteria) this;
        }

        public Criteria andDevIdIn(List<Integer> values) {
            addCriterion("dev_id in", values, "devId");
            return (Criteria) this;
        }

        public Criteria andDevIdNotIn(List<Integer> values) {
            addCriterion("dev_id not in", values, "devId");
            return (Criteria) this;
        }

        public Criteria andDevIdBetween(Integer value1, Integer value2) {
            addCriterion("dev_id between", value1, value2, "devId");
            return (Criteria) this;
        }

        public Criteria andDevIdNotBetween(Integer value1, Integer value2) {
            addCriterion("dev_id not between", value1, value2, "devId");
            return (Criteria) this;
        }

        public Criteria andDevTypeIsNull() {
            addCriterion("dev_type is null");
            return (Criteria) this;
        }

        public Criteria andDevTypeIsNotNull() {
            addCriterion("dev_type is not null");
            return (Criteria) this;
        }

        public Criteria andDevTypeEqualTo(Integer value) {
            addCriterion("dev_type =", value, "devType");
            return (Criteria) this;
        }

        public Criteria andDevTypeNotEqualTo(Integer value) {
            addCriterion("dev_type <>", value, "devType");
            return (Criteria) this;
        }

        public Criteria andDevTypeGreaterThan(Integer value) {
            addCriterion("dev_type >", value, "devType");
            return (Criteria) this;
        }

        public Criteria andDevTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("dev_type >=", value, "devType");
            return (Criteria) this;
        }

        public Criteria andDevTypeLessThan(Integer value) {
            addCriterion("dev_type <", value, "devType");
            return (Criteria) this;
        }

        public Criteria andDevTypeLessThanOrEqualTo(Integer value) {
            addCriterion("dev_type <=", value, "devType");
            return (Criteria) this;
        }

        public Criteria andDevTypeIn(List<Integer> values) {
            addCriterion("dev_type in", values, "devType");
            return (Criteria) this;
        }

        public Criteria andDevTypeNotIn(List<Integer> values) {
            addCriterion("dev_type not in", values, "devType");
            return (Criteria) this;
        }

        public Criteria andDevTypeBetween(Integer value1, Integer value2) {
            addCriterion("dev_type between", value1, value2, "devType");
            return (Criteria) this;
        }

        public Criteria andDevTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("dev_type not between", value1, value2, "devType");
            return (Criteria) this;
        }

        public Criteria andDevBrandIsNull() {
            addCriterion("dev_brand is null");
            return (Criteria) this;
        }

        public Criteria andDevBrandIsNotNull() {
            addCriterion("dev_brand is not null");
            return (Criteria) this;
        }

        public Criteria andDevBrandEqualTo(String value) {
            addCriterion("dev_brand =", value, "devBrand");
            return (Criteria) this;
        }

        public Criteria andDevBrandNotEqualTo(String value) {
            addCriterion("dev_brand <>", value, "devBrand");
            return (Criteria) this;
        }

        public Criteria andDevBrandGreaterThan(String value) {
            addCriterion("dev_brand >", value, "devBrand");
            return (Criteria) this;
        }

        public Criteria andDevBrandGreaterThanOrEqualTo(String value) {
            addCriterion("dev_brand >=", value, "devBrand");
            return (Criteria) this;
        }

        public Criteria andDevBrandLessThan(String value) {
            addCriterion("dev_brand <", value, "devBrand");
            return (Criteria) this;
        }

        public Criteria andDevBrandLessThanOrEqualTo(String value) {
            addCriterion("dev_brand <=", value, "devBrand");
            return (Criteria) this;
        }

        public Criteria andDevBrandLike(String value) {
            addCriterion("dev_brand like", value, "devBrand");
            return (Criteria) this;
        }

        public Criteria andDevBrandNotLike(String value) {
            addCriterion("dev_brand not like", value, "devBrand");
            return (Criteria) this;
        }

        public Criteria andDevBrandIn(List<String> values) {
            addCriterion("dev_brand in", values, "devBrand");
            return (Criteria) this;
        }

        public Criteria andDevBrandNotIn(List<String> values) {
            addCriterion("dev_brand not in", values, "devBrand");
            return (Criteria) this;
        }

        public Criteria andDevBrandBetween(String value1, String value2) {
            addCriterion("dev_brand between", value1, value2, "devBrand");
            return (Criteria) this;
        }

        public Criteria andDevBrandNotBetween(String value1, String value2) {
            addCriterion("dev_brand not between", value1, value2, "devBrand");
            return (Criteria) this;
        }

        public Criteria andDevMixIsNull() {
            addCriterion("dev_mix is null");
            return (Criteria) this;
        }

        public Criteria andDevMixIsNotNull() {
            addCriterion("dev_mix is not null");
            return (Criteria) this;
        }

        public Criteria andDevMixEqualTo(String value) {
            addCriterion("dev_mix =", value, "devMix");
            return (Criteria) this;
        }

        public Criteria andDevMixNotEqualTo(String value) {
            addCriterion("dev_mix <>", value, "devMix");
            return (Criteria) this;
        }

        public Criteria andDevMixGreaterThan(String value) {
            addCriterion("dev_mix >", value, "devMix");
            return (Criteria) this;
        }

        public Criteria andDevMixGreaterThanOrEqualTo(String value) {
            addCriterion("dev_mix >=", value, "devMix");
            return (Criteria) this;
        }

        public Criteria andDevMixLessThan(String value) {
            addCriterion("dev_mix <", value, "devMix");
            return (Criteria) this;
        }

        public Criteria andDevMixLessThanOrEqualTo(String value) {
            addCriterion("dev_mix <=", value, "devMix");
            return (Criteria) this;
        }

        public Criteria andDevMixLike(String value) {
            addCriterion("dev_mix like", value, "devMix");
            return (Criteria) this;
        }

        public Criteria andDevMixNotLike(String value) {
            addCriterion("dev_mix not like", value, "devMix");
            return (Criteria) this;
        }

        public Criteria andDevMixIn(List<String> values) {
            addCriterion("dev_mix in", values, "devMix");
            return (Criteria) this;
        }

        public Criteria andDevMixNotIn(List<String> values) {
            addCriterion("dev_mix not in", values, "devMix");
            return (Criteria) this;
        }

        public Criteria andDevMixBetween(String value1, String value2) {
            addCriterion("dev_mix between", value1, value2, "devMix");
            return (Criteria) this;
        }

        public Criteria andDevMixNotBetween(String value1, String value2) {
            addCriterion("dev_mix not between", value1, value2, "devMix");
            return (Criteria) this;
        }

        public Criteria andSeriesIsNull() {
            addCriterion("series is null");
            return (Criteria) this;
        }

        public Criteria andSeriesIsNotNull() {
            addCriterion("series is not null");
            return (Criteria) this;
        }

        public Criteria andSeriesEqualTo(String value) {
            addCriterion("series =", value, "series");
            return (Criteria) this;
        }

        public Criteria andSeriesNotEqualTo(String value) {
            addCriterion("series <>", value, "series");
            return (Criteria) this;
        }

        public Criteria andSeriesGreaterThan(String value) {
            addCriterion("series >", value, "series");
            return (Criteria) this;
        }

        public Criteria andSeriesGreaterThanOrEqualTo(String value) {
            addCriterion("series >=", value, "series");
            return (Criteria) this;
        }

        public Criteria andSeriesLessThan(String value) {
            addCriterion("series <", value, "series");
            return (Criteria) this;
        }

        public Criteria andSeriesLessThanOrEqualTo(String value) {
            addCriterion("series <=", value, "series");
            return (Criteria) this;
        }

        public Criteria andSeriesLike(String value) {
            addCriterion("series like", value, "series");
            return (Criteria) this;
        }

        public Criteria andSeriesNotLike(String value) {
            addCriterion("series not like", value, "series");
            return (Criteria) this;
        }

        public Criteria andSeriesIn(List<String> values) {
            addCriterion("series in", values, "series");
            return (Criteria) this;
        }

        public Criteria andSeriesNotIn(List<String> values) {
            addCriterion("series not in", values, "series");
            return (Criteria) this;
        }

        public Criteria andSeriesBetween(String value1, String value2) {
            addCriterion("series between", value1, value2, "series");
            return (Criteria) this;
        }

        public Criteria andSeriesNotBetween(String value1, String value2) {
            addCriterion("series not between", value1, value2, "series");
            return (Criteria) this;
        }

        public Criteria andLackPartIsNull() {
            addCriterion("lack_part is null");
            return (Criteria) this;
        }

        public Criteria andLackPartIsNotNull() {
            addCriterion("lack_part is not null");
            return (Criteria) this;
        }

        public Criteria andLackPartEqualTo(String value) {
            addCriterion("lack_part =", value, "lackPart");
            return (Criteria) this;
        }

        public Criteria andLackPartNotEqualTo(String value) {
            addCriterion("lack_part <>", value, "lackPart");
            return (Criteria) this;
        }

        public Criteria andLackPartGreaterThan(String value) {
            addCriterion("lack_part >", value, "lackPart");
            return (Criteria) this;
        }

        public Criteria andLackPartGreaterThanOrEqualTo(String value) {
            addCriterion("lack_part >=", value, "lackPart");
            return (Criteria) this;
        }

        public Criteria andLackPartLessThan(String value) {
            addCriterion("lack_part <", value, "lackPart");
            return (Criteria) this;
        }

        public Criteria andLackPartLessThanOrEqualTo(String value) {
            addCriterion("lack_part <=", value, "lackPart");
            return (Criteria) this;
        }

        public Criteria andLackPartLike(String value) {
            addCriterion("lack_part like", value, "lackPart");
            return (Criteria) this;
        }

        public Criteria andLackPartNotLike(String value) {
            addCriterion("lack_part not like", value, "lackPart");
            return (Criteria) this;
        }

        public Criteria andLackPartIn(List<String> values) {
            addCriterion("lack_part in", values, "lackPart");
            return (Criteria) this;
        }

        public Criteria andLackPartNotIn(List<String> values) {
            addCriterion("lack_part not in", values, "lackPart");
            return (Criteria) this;
        }

        public Criteria andLackPartBetween(String value1, String value2) {
            addCriterion("lack_part between", value1, value2, "lackPart");
            return (Criteria) this;
        }

        public Criteria andLackPartNotBetween(String value1, String value2) {
            addCriterion("lack_part not between", value1, value2, "lackPart");
            return (Criteria) this;
        }

        public Criteria andFaultDepressionIsNull() {
            addCriterion("fault_depression is null");
            return (Criteria) this;
        }

        public Criteria andFaultDepressionIsNotNull() {
            addCriterion("fault_depression is not null");
            return (Criteria) this;
        }

        public Criteria andFaultDepressionEqualTo(String value) {
            addCriterion("fault_depression =", value, "faultDepression");
            return (Criteria) this;
        }

        public Criteria andFaultDepressionNotEqualTo(String value) {
            addCriterion("fault_depression <>", value, "faultDepression");
            return (Criteria) this;
        }

        public Criteria andFaultDepressionGreaterThan(String value) {
            addCriterion("fault_depression >", value, "faultDepression");
            return (Criteria) this;
        }

        public Criteria andFaultDepressionGreaterThanOrEqualTo(String value) {
            addCriterion("fault_depression >=", value, "faultDepression");
            return (Criteria) this;
        }

        public Criteria andFaultDepressionLessThan(String value) {
            addCriterion("fault_depression <", value, "faultDepression");
            return (Criteria) this;
        }

        public Criteria andFaultDepressionLessThanOrEqualTo(String value) {
            addCriterion("fault_depression <=", value, "faultDepression");
            return (Criteria) this;
        }

        public Criteria andFaultDepressionLike(String value) {
            addCriterion("fault_depression like", value, "faultDepression");
            return (Criteria) this;
        }

        public Criteria andFaultDepressionNotLike(String value) {
            addCriterion("fault_depression not like", value, "faultDepression");
            return (Criteria) this;
        }

        public Criteria andFaultDepressionIn(List<String> values) {
            addCriterion("fault_depression in", values, "faultDepression");
            return (Criteria) this;
        }

        public Criteria andFaultDepressionNotIn(List<String> values) {
            addCriterion("fault_depression not in", values, "faultDepression");
            return (Criteria) this;
        }

        public Criteria andFaultDepressionBetween(String value1, String value2) {
            addCriterion("fault_depression between", value1, value2, "faultDepression");
            return (Criteria) this;
        }

        public Criteria andFaultDepressionNotBetween(String value1, String value2) {
            addCriterion("fault_depression not between", value1, value2, "faultDepression");
            return (Criteria) this;
        }

        public Criteria andFaultTypeIsNull() {
            addCriterion("fault_type is null");
            return (Criteria) this;
        }

        public Criteria andFaultTypeIsNotNull() {
            addCriterion("fault_type is not null");
            return (Criteria) this;
        }

        public Criteria andFaultTypeEqualTo(Integer value) {
            addCriterion("fault_type =", value, "faultType");
            return (Criteria) this;
        }

        public Criteria andFaultTypeNotEqualTo(Integer value) {
            addCriterion("fault_type <>", value, "faultType");
            return (Criteria) this;
        }

        public Criteria andFaultTypeGreaterThan(Integer value) {
            addCriterion("fault_type >", value, "faultType");
            return (Criteria) this;
        }

        public Criteria andFaultTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("fault_type >=", value, "faultType");
            return (Criteria) this;
        }

        public Criteria andFaultTypeLessThan(Integer value) {
            addCriterion("fault_type <", value, "faultType");
            return (Criteria) this;
        }

        public Criteria andFaultTypeLessThanOrEqualTo(Integer value) {
            addCriterion("fault_type <=", value, "faultType");
            return (Criteria) this;
        }

        public Criteria andFaultTypeIn(List<Integer> values) {
            addCriterion("fault_type in", values, "faultType");
            return (Criteria) this;
        }

        public Criteria andFaultTypeNotIn(List<Integer> values) {
            addCriterion("fault_type not in", values, "faultType");
            return (Criteria) this;
        }

        public Criteria andFaultTypeBetween(Integer value1, Integer value2) {
            addCriterion("fault_type between", value1, value2, "faultType");
            return (Criteria) this;
        }

        public Criteria andFaultTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("fault_type not between", value1, value2, "faultType");
            return (Criteria) this;
        }

        public Criteria andApperanceIsNull() {
            addCriterion("apperance is null");
            return (Criteria) this;
        }

        public Criteria andApperanceIsNotNull() {
            addCriterion("apperance is not null");
            return (Criteria) this;
        }

        public Criteria andApperanceEqualTo(String value) {
            addCriterion("apperance =", value, "apperance");
            return (Criteria) this;
        }

        public Criteria andApperanceNotEqualTo(String value) {
            addCriterion("apperance <>", value, "apperance");
            return (Criteria) this;
        }

        public Criteria andApperanceGreaterThan(String value) {
            addCriterion("apperance >", value, "apperance");
            return (Criteria) this;
        }

        public Criteria andApperanceGreaterThanOrEqualTo(String value) {
            addCriterion("apperance >=", value, "apperance");
            return (Criteria) this;
        }

        public Criteria andApperanceLessThan(String value) {
            addCriterion("apperance <", value, "apperance");
            return (Criteria) this;
        }

        public Criteria andApperanceLessThanOrEqualTo(String value) {
            addCriterion("apperance <=", value, "apperance");
            return (Criteria) this;
        }

        public Criteria andApperanceLike(String value) {
            addCriterion("apperance like", value, "apperance");
            return (Criteria) this;
        }

        public Criteria andApperanceNotLike(String value) {
            addCriterion("apperance not like", value, "apperance");
            return (Criteria) this;
        }

        public Criteria andApperanceIn(List<String> values) {
            addCriterion("apperance in", values, "apperance");
            return (Criteria) this;
        }

        public Criteria andApperanceNotIn(List<String> values) {
            addCriterion("apperance not in", values, "apperance");
            return (Criteria) this;
        }

        public Criteria andApperanceBetween(String value1, String value2) {
            addCriterion("apperance between", value1, value2, "apperance");
            return (Criteria) this;
        }

        public Criteria andApperanceNotBetween(String value1, String value2) {
            addCriterion("apperance not between", value1, value2, "apperance");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNull() {
            addCriterion("password is null");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNotNull() {
            addCriterion("password is not null");
            return (Criteria) this;
        }

        public Criteria andPasswordEqualTo(String value) {
            addCriterion("password =", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotEqualTo(String value) {
            addCriterion("password <>", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThan(String value) {
            addCriterion("password >", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("password >=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThan(String value) {
            addCriterion("password <", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThanOrEqualTo(String value) {
            addCriterion("password <=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLike(String value) {
            addCriterion("password like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotLike(String value) {
            addCriterion("password not like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordIn(List<String> values) {
            addCriterion("password in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotIn(List<String> values) {
            addCriterion("password not in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordBetween(String value1, String value2) {
            addCriterion("password between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotBetween(String value1, String value2) {
            addCriterion("password not between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andAlterTimeIsNull() {
            addCriterion("alter_time is null");
            return (Criteria) this;
        }

        public Criteria andAlterTimeIsNotNull() {
            addCriterion("alter_time is not null");
            return (Criteria) this;
        }

        public Criteria andAlterTimeEqualTo(Date value) {
            addCriterion("alter_time =", value, "alterTime");
            return (Criteria) this;
        }

        public Criteria andAlterTimeNotEqualTo(Date value) {
            addCriterion("alter_time <>", value, "alterTime");
            return (Criteria) this;
        }

        public Criteria andAlterTimeGreaterThan(Date value) {
            addCriterion("alter_time >", value, "alterTime");
            return (Criteria) this;
        }

        public Criteria andAlterTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("alter_time >=", value, "alterTime");
            return (Criteria) this;
        }

        public Criteria andAlterTimeLessThan(Date value) {
            addCriterion("alter_time <", value, "alterTime");
            return (Criteria) this;
        }

        public Criteria andAlterTimeLessThanOrEqualTo(Date value) {
            addCriterion("alter_time <=", value, "alterTime");
            return (Criteria) this;
        }

        public Criteria andAlterTimeIn(List<Date> values) {
            addCriterion("alter_time in", values, "alterTime");
            return (Criteria) this;
        }

        public Criteria andAlterTimeNotIn(List<Date> values) {
            addCriterion("alter_time not in", values, "alterTime");
            return (Criteria) this;
        }

        public Criteria andAlterTimeBetween(Date value1, Date value2) {
            addCriterion("alter_time between", value1, value2, "alterTime");
            return (Criteria) this;
        }

        public Criteria andAlterTimeNotBetween(Date value1, Date value2) {
            addCriterion("alter_time not between", value1, value2, "alterTime");
            return (Criteria) this;
        }

        public Criteria andSIdIsNull() {
            addCriterion("s_id is null");
            return (Criteria) this;
        }

        public Criteria andSIdIsNotNull() {
            addCriterion("s_id is not null");
            return (Criteria) this;
        }

        public Criteria andSIdEqualTo(Integer value) {
            addCriterion("s_id =", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdNotEqualTo(Integer value) {
            addCriterion("s_id <>", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdGreaterThan(Integer value) {
            addCriterion("s_id >", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("s_id >=", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdLessThan(Integer value) {
            addCriterion("s_id <", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdLessThanOrEqualTo(Integer value) {
            addCriterion("s_id <=", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdIn(List<Integer> values) {
            addCriterion("s_id in", values, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdNotIn(List<Integer> values) {
            addCriterion("s_id not in", values, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdBetween(Integer value1, Integer value2) {
            addCriterion("s_id between", value1, value2, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdNotBetween(Integer value1, Integer value2) {
            addCriterion("s_id not between", value1, value2, "sId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}